Delve inside the core SQL Server engine--and put that knowledge to work--with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you'll gain the deep knowledge you need to exploit key architectural changes--and capture the product's full po[...]

If you've designed your SQL code intelligently, and implemented a sensible indexing strategy, there's a good chance your queries will "fly", when tested in isolation. In the real world, however, where multiple processes can access the same data at the same time, SQL Server often has to make one proc[...]

DESCRIPTION SQL Server is a big, powerful database, and it boasts an equally big and powerful community of professionals. Over 50 of the best known SQL Server gurus, each designated by Microsoft as a Most Valuable Professional, offer their favorite tips, techniques, and insights in this unique book.[...]